package com.trkj.dao.jpa;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.LmbConsumableCollarDetail;

public interface LmbConsumableCollarDetailDAO extends CrudRepository<LmbConsumableCollarDetail,String>{
	@Query("select max(c.cdId) from LmbConsumableCollarDetail c where c.cdId like ?1%")
    public String findMaxID(String a);
	
	@Query("select c from LmbConsumableCollarDetail c where c.cdCollarId =?1 order by c.cdId asc")
	public List<LmbConsumableCollarDetail> findByCollarId(String collarId);
	
}
